package cn.cai.mapper;

import cn.cai.pojo.BasicInformation;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * 基本信息表的数据库操作
 */
@Mapper
public interface BasicInformationMapper {
    @Select("select * from basic_information")
    List<BasicInformation> selectAll();

    @Insert("insert into basic_information(xh, nl, lxfs, jzdq, jzdq_xxdz, tw,reporting_time,mail) value " +
            "(#{information.xh},#{information.nl},#{information.lxfs},#{information.jzdq},#{information.jzdqXxdz},#{information.tw},#{information.reportingTime},#{information.mail})")
    Integer inertInfromation(@Param("information") BasicInformation basicInformation);

    @Delete("delete from basic_information where xh = #{xh}")
    Integer deleteInformation(String xh);
}
